﻿
CREATE PROCEDURE [dbo].[proc_APP_Roles_GetList]
	
	(
	@page INT,
	@num int
	)
	
AS
	
SELECT * FROM (	
	SELECT Mid,FAdminFlg, Cid, Did, RName, RNote, ID,EntryTime, EntryPeople,ROW_NUMBER() over(order by id) as row
	,(select count(1) from  App_Roles ) as zjls FROM App_Roles 
) AS n_t
WHERE    row> @num *(@page - 1)   and row<=  @page * @num  

ORDER BY id	  	  

RETURN



